from ..extensions import db


class CarSales(db.Model):
    __tablename__ = 'car_sales'

    id = db.Column(db.Integer, primary_key=True)
    year = db.Column(db.Integer, nullable=False)
    month = db.Column(db.Integer, nullable=False)
    ranking = db.Column(db.Integer, nullable=False)
    model = db.Column(db.String(100), nullable=False)
    manufacturer = db.Column(db.String(100), nullable=False)
    sales_volume = db.Column(db.Integer, nullable=False)
    price_range = db.Column(db.String(50))
